package com.mrx.pvzcommunity.dao;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface SiteInfoDao {

    @Select("SELECT COUNT(*) FROM plants")
    Integer countPlants();

    @Select("SELECT COUNT(*) FROM zombies")
    Integer countZombies();

    @Select("SELECT COUNT(*) FROM users")
    Integer countUsers();

    @Select("SELECT COUNT(*) FROM threads")
    Integer countUserThreads();

    @Select("SELECT COUNT(*) FROM comments")
    Integer countComments();
}
